FO_Providers
Field | Type | Notes |
---|---|---|
Provider_ID |
int |
ID field, a counter. Unique |
Code |
varchar(50) |
Enter a unique code for the physician. |
Name |
varchar(255) |
Name or description for the physician. |
Number |
varchar(50) |
Default billing number for this physician. Enter alphanumeric code as the billing number. This number will override the account entry on the order screen. Enter 'ASK' to make the system prompt for an account number when the physician is chosen on the order screen. |
EntryGroupCode |
varchar(50) |
Entry group code for this physician. Enter a valid group code. Used to assign patients to this physician so user can search only for those patients during inquiry. |
InquiryGroupCode |
varchar(50) |
Inquiry group code for this physician. Enter a valid group code. Used to assign patients to this physician so user can search only for those patients during inquiry. |
Add1 |
varchar(80) |
First address line. |
Add2 |
varchar(80) |
Second address line. |
City |
varchar(50) |
City |
St |
varchar(50) |
State |
Zip |
varchar(50) |
Zip code |
Tel |
varchar(50) |
Phone number |
Fax |
varchar(50) |
Fax number |
License |
varchar(50) |
License number for the physician. |
Comments |
varchar(50) |
Notes related to the physician. |
UPIN |
varchar(50) |
UPIN number |
HID |
varchar(50) |
The LIS HID value. |
|
varchar(255) |
Email address for this physician. |
UserName |
varchar(50) |
User name associated with this physician. |
CreateDate |
datetime |
Date record was created. Informational |
EditDate |
datetime |
Date record was late created. Informational |
Active |
varchar(50) |
Bit flag to indicate if this provider physician should be included in searches. Enter 0 or 1 0 = not active, system will not find it in searches 1 = active, system will include in searches |
FacilityID |
varchar(50) |
Default system facility ID for the physician. |
LabPopup |
varchar(255) |
Message text to appear on the order screen when the provider is selectd by a lab user. |
ClientPopup |
varchar(255) |
Message text to appear on the order screen when the provider is selectd by a client user. |
AutoOrderTests |
varchar(255) |
A list of test codes to be ordered automatically when this provider is selected on the order screen. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid test codes separated by pipes. The rule fires when the first code is ordered. |
ProvPerfLabGrp |
varchar(50) |
Represents a grouping code to be used in the performing lab assignment processing rule. Allows for the grouping of physicians into groups so more generic rules can be written for performing lab assignments. |
Mnemonic |
varchar(50) |
A code for which the system also searches pen performing a physician search on the order screen. |
AutoOrderTestsCC |
varchar(255) |
A list of test codes to be ordered automatically when this provider is selected as a copy to on the order screen. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid test codes separated by pipes. The rule fires when the first code is ordered. |
PreventOrdersForINS |
varchar(500) |
A list of insurance codes used to drive a rule that does not allow the user to create any tests for this physician and any insurance codes in the list. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid insurance codes separated by pipes. The rule fires when a test order is placed on the order screen. A message is displayed warning that no orders can be entered. |
NPI |
varchar(50) |
NPI value |
LastName |
varchar(80) |
Last name of this physician provider. |
FirstName |
varchar(80) |
First name of this physician provider. |
MiddleName |
varchar(80) |
Middle name of this physician provider. |
Title |
varchar(50) |
Title for this physician provider. |
CellPhone |
varchar(50) |
Cell phone number |
Pager |
varchar(50) |
Pager phone number |
Tel2 |
varchar(50) |
Additional phone number |
Tel3 |
varchar(50) |
Additional phone number |
Country |
varchar(50) |
Country |
AddressType |
varchar(50) |
Informational |
Department |
varchar(50) |
Informational |
Service |
varchar(50) |
Informational |
Specialty |
varchar(50) |
Informational |
LicenseState |
varchar(50) |
State where provider physician's license was issued. Enter the standard two character state postal abbreviation. |
DEA |
varchar(50) |
DEA code for provider physician. |
RptTriggerSubscriptionID |
varchar(50) |
Used with RRE reporting tool. Enter a valid subscription ID. |
DoNotAllowAsOrdering |
bit |
Bit flag to indicate if this provider physician can be selected as ordering provider. Enter 0 or 1 0 = do not allow selection 1 = allow selection |
DoNotAllowAsCopyTo |
bit |
Bit flag to indicate if this provider physician can be selected as copy to provider. Enter 0 or 1 0 = do not allow selection 1 = allow selection |
LabCode |
varchar(50) |
Lab code used for this client. Enter a valid lab code. |
SourceSystem |
varchar(50) |
Default system/vendor/version ID for this provider. Enter a valid ID. Connects to the organization source system definitions. |